[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '9' >
6 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39 | 12.45 | 2001-04-23 | Production | simon0@adventure-works.com | Simon Rapier | 963-555-0134 | 276751903 | Simon | M | 2019-11-15 | Rapier | adventure-works\simon0 | S | D | 9 | 1 | 963-555-0134 | | 39 | 2019-11-15 | Current | Production Technician - WC60 | 38 |
| 78 | 12.45 | 1995-07-02 | Production | james0@adventure-works.com | James Kramer | 119-555-0117 | 339712426 | James | M | 2019-12-04 | Kramer | adventure-works\james0 | M | D | 9 | 1 | 119-555-0117 | | 39 | 2019-12-04 | Current | Production Technician - WC60 | 39 |
| 86 | 12.45 | 1999-10-27 | Production | nancy0@adventure-works.com | Nancy Anderson | 970-555-0118 | 693325305 | Nancy | F | 2019-12-10 | Anderson | adventure-works\nancy0 | M | A | 9 | 1 | 970-555-0118 | | 37 | 2019-12-10 | Current | Production Technician - WC60 | 34 |
| 125 | 12.45 | 1984-08-03 | Production | bryan0@adventure-works.com | Bryan Baker | 712-555-0113 | 458159238 | Bryan | M | 2019-12-29 | Baker | adventure-works\bryan0 | S | 9 | 1 | 712-555-0113 | | 37 | 2019-12-29 | Current | Production Technician - WC60 | 35 | |
| 160 | 12.45 | 1987-01-17 | Production | eugene1@adventure-works.com | Eugene Kogan | 173-555-0179 | 66073987 | Eugene | M | 2020-01-16 | Kogan | adventure-works\eugene1 | S | O | 9 | 1 | 173-555-0179 | | 38 | 2020-01-16 | Current | Production Technician - WC60 | 36 |
| 198 | 12.45 | 1996-12-17 | Production | thomas0@adventure-works.com | Thomas Michaels | 278-555-0118 | 500412746 | Thomas | M | 2020-02-03 | Michaels | adventure-works\thomas0 | M | R | 9 | 1 | 278-555-0118 | | 38 | 2020-02-03 | Current | Production Technician - WC60 | 37 |
Generated 2025-06-06 16:36:59.131 UTC